What is informatica worklet?

601

Enlist the tasks for which source qualifier transformation is used.

580

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1455

How do you set a varible in incremental aggregation

1432

What are the types of data warehouses?

936

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

587

What is Index Caches size?

609

How do you convert single row from source into three rows into target?

594

What do you mean by channel change?

531

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

603

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1241

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1506

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1580

Please let me know how to make encryption and decryption with example?

1453

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

637