1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi,
In a mapping I have 3 targets and one fixed width file as
source. Total 193 records are there .
I connected one port in aggregator to all 3 targets.
The same value need to be load into these 3 targets . It is
loaded like that only but in different order.
Why?
The order of insertion should be same know for all 3 targets
? Then why the order is changed ?
Any one please help me.
Advance thanks.

Question Posted / c manojkumar

Answers were Sorted based on User's Feedback



Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / manojkumar challagundla

Hi Sateesh,
I am asking about order of insertion .

Is This Answer Correct ?    0 Yes 0 No

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / sateesh a

passthrough-->true and default groups are different.

Is This Answer Correct ?    0 Yes 0 No

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / zipzapdhoom

informatica don't consider the sequence of records at the
time of insertion to Target , for that u should use a
sequence generator TF. or u can use sorter.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

How many repositories can we create in Informatica?

3 Answers  

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.

0 Answers   CTS,

why we use informatica in our project?

2 Answers   TCS,




what is a transforamation?

5 Answers  

what is session override?

2 Answers   Cap Gemini,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

Can u generate reports in Informatica?

0 Answers   Informatica,

Mention few power centre client applications with their basic purpose?

0 Answers  

What is galaxy shema

2 Answers   CGI,

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories