How to generate sequence numbers without using the sequence generator transformation?
No Answer is Posted For this Question
Be the First to Post Answer
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How can a transformation be made reusable?
What are two types of processes that informatica runs the session?
How to delete duplicate records in a flat file source?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what is persistant cache in which situation we will use persistantcache
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.