what is lookup ?6 5846
what is the flow?1 2753
In update strategy target table or flat file which gives more performance ? why?7 13163
Why touse stored procedure in ETL Application?2 5889
What is critical mapping?2 5134
How to view and Generate Metadata Reports?1 3312
what is the gap analysis?1 4985
How to recover sessions in concurrent batches?3 8775
what are the different types of transformation available in informatica and what are the mostly used ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
waht type of interface is used for testing the data in informatica
what is the difference between informatica6.1 and infomatica7.1
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are factless facts? And in which scenario will you use such kinds of fact tables.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is the size of your data warehousing?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
explain about unit testing? in real time?