Informatica Interview Questions
Questions Answers Views Company eMail

From where you extract the data, how you did it into informatica? explain....

Accenture, Unisoft Infotech,

1 5232

What are your source in project and how you import in informatica? How can i explain abt this?

Accenture, Unisoft Infotech,

1 5756

What are events in workflow manager?

Accenture, IBM,

1 8028

Enterprise data warehouse your projects phase by phase explain?

Cap Gemini,

1431

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

ABC, Cap Gemini,

4 8471

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

Logica CMG,

3 9851

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

Logica CMG,

3 7014

How to add source flat file header into target file?

Logica CMG,

3 7541

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

TCS,

7640

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

DELL,

1 6965

Does Facttable Normalized or Denormalized?

IBM,

2 7200

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

Cap Gemini,

7 10850

Informatica and datawarehousing courses in Pune?

2 4472

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

DELL, iGate,

2 8283

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

1577


Post New Informatica Questions

Un-Answered Questions { Informatica }

waht type of interface is used for testing the data in informatica

1814


Design a mapping to load the cumulative sum of salaries of employees into target table?

868


How do you load first and last records into target table?

641


Where can we find the throughput option in informatica?

577


What is the format of informatica objects in a repository?

579






How to convert multiple rows to single row (multiple columns) in informatica

861


What are the limitations of joiner transformation?

629


How to update or delete the rows in a target, which do not have key fields?

629


Where are the source flat files kept before running the session?

594


What are the different transaction levels available in transaction control transformation?

646


Explain lookup transformation is active in informatica

634


What is a sorter transformation?

636


What is union transformation?

550


What if the source is a flat-file?

568


Under which circumstances, informatica server creates reject files?

572