How big was your fact table
No Answer is Posted For this Question
Be the First to Post Answer
Mention some types of transformation?
Explain lookup transformation source types in informatica
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What is blocking transformation?
What is the difference between view and materialised view?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
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.
Is it possible to update the target table with PK?
how to join the two flatfiles using the joiner t/r if there is no matching port?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
What is meant by pre and post session shell command?