Informatica Interview Questions
Questions Answers Views Company eMail

I have a flat file, want to reverse the contents of the flat file

Informatica,

693

which one is better performance wise joiner or look up

Informatica,

626

write a query to retrieve the latest records from the table sorted by version(scd)

Informatica,

631

How many types of sessions are there in informatica.please explain them?

Informatica,

678

Which transformation is needed while using the Cobol sources as source definitions?

Informatica,

727

What is an unconnected transformation?

Informatica,

661

What is the status code in stored procedure transformation?

Informatica,

683

Explain dynamic target flat file name generation in informatica

Informatica,

648

update strategy transformation in informatica

Informatica,

642

Difference between Data and Index Caches?

Informatica,

653

How many ways are there to create ports?

Informatica,

727

Which means the first record should come as last record and last record should come as first record and load into the target file?

Informatica,

610

What is blocking transformation?

Informatica,

717

Explain the tuning lookup transformation - informatica

Informatica,

611

Explain about Informatica server process that how it works relates to mapping variables?

Informatica,

622


Post New Informatica Questions

Un-Answered Questions { Informatica }

State the differences between sql override and lookup override?

622


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

634


What is dynamic cache?

612


Repository user profiles

1375


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

721






SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1684


What is difference between a gateway node and worker node?

625


What is the maplet?

620


As union transformation gives UNION ALL output, how you will get the UNION output?

641


How can we use batches?

604


how to load dimension table and fact table. plz tell me the steps.

1683


What does command task mean?

610


Describe data concatenation?

570


What is the need of an ETL tool?

640


How can you define user defied event?

618