Technology | Practice Questions | Aliensbrain

Multiple choice technology

The session fails if you delete lookup ports from flat file lookup.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

While importing/replacing tables into Informatica, which of the following is the right way to go about?

Import/Replace into source analyser and then to target designer.
Import/Replace into target designer and then to source analyser.
Both a and b.
None of these.

Reveal answer Fill a bubble to check yourself

Multiple choice technology

The data required for the lookup is read from it’s source only once in a single session.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

Unconnected sequence generator can be used instead of a connected sequence generator to perform the intended work.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

The position of filter transformation in a mapping does not affect the performance.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

If file paths for source, target, session log, bad & cache files point to a directory that the Informatica server does not have permission to write to, then

The session will not initiate.
The session will initiate but will fail.
The session will run successfully without writing the source, target, log, bad & cache files.
The session will run successfully & write successfully into the source, target, log, bad & cache files.

Reveal answer Fill a bubble to check yourself

Multiple choice technology

When setting up a session for the first time Informatica defaults to use the first connection in the list.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

There is always overhead involved in moving data between transformations as each transformation results in the creation of temporary cache files.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology

Which of the following is strictly active/connected transformation?

Lookup
Expression
Stored Procedure
Transaction Control

Reveal answer Fill a bubble to check yourself

Multiple choice technology

The rank transformation requires a minimum of one input & output port, an optional variable port and strictly only one return port.

True
False

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology