| Other Informatica Interview Questions |
|| Asked @
|I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 For more clarification i
want to elimate nulls and want in a single line. Please
help me out
|how you will maintain version?
|Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
|If a table contains 100 records we have to fetch 50-100
records from source to target?how
|what are the perameter and variable?
name gender name target
a1 male a1 female
a2 female a2 male
i want a1 female update to target how will do?
|What are the basic needs to join two sources in a source
|How to recover sessions in concurrent batches?
|What is best approach to load 100 different source files
(Different structure) to differet target tables ?
|What is Target Update Override? What is the Use ?
|How to compare Source and Target table, without using
6 VASU HERE I WANT NON MATCHING
RECORDS I WANT HOW TO ACHIEVE THAT
|For more Informatica Interview Questions Click Here |