How to generate or load values in to the target table based on a column value using informatica etl tool.


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

Post New Answer

More Informatica Interview Questions

What do you mean by channel change?

0 Answers  


What are the different options available for update strategy?

0 Answers  


What are the challenges of Dataware housing in the future?

2 Answers   HP,


Parameter and variable differences

0 Answers  


What is a candidate key?

7 Answers   CTS,






How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  


hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  


Categories