Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways you create ports?
- 1 Answers
- 5986 Views
- I also Faced
- E-Mail Answers
Answer / swetha
Two ways
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
| Is This Answer Correct ? | 5 Yes | 0 No |
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is target designer and target load order?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
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?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
How can you access the remote source into your session?
What do you mean by blocking transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is target load order?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Teradata 
