Search:

Can any one explain the scenario for the below one.

If there are more than 10000 files which are in same format and datatypes, which are having different names. How will you handle them in...

hi,
Is it possible to write a update and insert in a single query, i.e., what we do in update strategy transformation. if yes pls give on example or query?

hi Manisha,
yes, we can see them in log files, i.e., what ever we do in informatica designer, that backend SQL code will be seen in log files. These files are created by Power center...

Hi, How will u implement many to many relationship in star schema model?

Hi, I have some idea about that. Pls, reply whether these are correct or not
1. We can remove them at staging area, by using SQL before entering into informatica.
2. By using aggregator...