i had a source containing business,sales,details column and
i have to load it to a target but i have some bad records
in it , but i have to load 70% of business records and 50%
of sales and 95% of details records excluding bad records
to achieve this what should be done and what all logic and
tx should be used can anyone help? thanks in advance


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is mean by complex business rule ?

0 Answers   Cap Gemini,


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  


How to load a Dimension ? and how to load a fact table?

0 Answers  


100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,






write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  


Explain pushdown optimization and types in informatica

0 Answers   Informatica,


Describe data concatenation?

0 Answers  


I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


Categories