Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table
ID NAME SAL
101 A 1000
102 B 2000
103 C 1500
target load should be
ID NAME SAL
101 A 1000
101 B 2000
101 C 1500
102 A 1000
102 B 2000
102 C 1500
103 A 1000
103 B 2000
103 C 1500
- 3 Answers
- 6272 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK
IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Repository user profiles
What is aggregate cache in aggregator transformation?
How you can differentiate between connected lookup and unconnected lookup?
Different circumstance which drives informatica server to expel records?
How to handle decimal places while importing a flatfile into informatica?
Explain lookup transformation in informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
define galaxy repository in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What does update strategy mean, and what are the different option of it?
What is target designer and target load order?
What are the different lookup cache(s)?
How can a transformation be made reusable?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can we create multiple integration service on single repository?
