Explain scd type 3 through mapping.
No Answer is Posted For this Question
Be the First to Post Answer
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.
where to store informatica rejected data? How to extract the informatica rejected data?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
How many types of sessions are there in informatica.please explain them?
What are the different versions of informatica?
What are the different types of olap? Give an example?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What is the procedure to load the fact table.Give in detail?
how to delete duplicate records by using filter transfermation?
HOW TO YOU LOAD TIME DIMENSION
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?