Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 6092

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

Accenture, Unisoft Infotech,

1 6499

What are events in workflow manager?

Accenture, IBM,

1 8827

Enterprise data warehouse your projects phase by phase explain?

Cap Gemini,

1921

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 10167

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

Logica CMG,

3 11116

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

Logica CMG,

3 8369

How to add source flat file header into target file?

Logica CMG,

3 9191

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

TCS,

8202

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 7940

Does Facttable Normalized or Denormalized?

IBM,

2 8153

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 12635

Informatica and datawarehousing courses in Pune?

2 5411

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 9297

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.

2005

Post New Informatica Questions

Un-Answered Questions { Informatica }

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038

what is degenerated dimension?

3997

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

What is the Process to creating lookup transformation in informatica

1045

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

1166

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

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

2131

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1863

Explain the difference between a data warehouse and a data mart?

1056

In informatica workflow manager, how many repositories can be created?

1362

What does command task mean?

1149

What is meant by query override?

1060

Explain the different lookup methods used in informatica?

1042

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2304

Explain the scenario which compels informatica server to reject files?

1168

For More Un-Answered { Informatica } Questions Click Here