What is the target load order?
Answers were Sorted based on User's Feedback
Answer / swetha
yoU specify the target load order based on source qualifiers
in a maping. If u have the multiple source qualifiers
connected to the multiple targets, yoU can designatethe
order in which informatica server loads data into the targets.
Is This Answer Correct ? | 15 Yes | 2 No |
Answer / kareem
By using the target load order,We can order the target's
(i.e In which target ou like to load the data first)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rashmi garg
when we set the target load order, we create the groups,
each group may have multiple targets.
so data is loaded concurrently in all the targets of one
group and sequentially in different groups in the order.
Is This Answer Correct ? | 0 Yes | 8 No |
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
what is sql override?what is the use of it?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is the functionality of update strategy?
Under what condition selecting sorted input in aggregator may fail the session?
What are session parameters ? How do you set them?
what is the logic will you implement to load data into a fact table from n dimension tables?
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.
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Can you copy the session to a different folder or repository?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar