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
- 6458 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
differences between service based and product based?
Explain sql transformation in script mode examples in informatica
Explain the informatica workflow?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is size of u r database?
How to elaborate tracing level?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Write the unconnected lookup syntax and how to return more than one column.
Where can we find the throughput option in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load first and last records into target table?
whats the logic to load the lower level of granularity of data to fact table.
Sequence generator, when you move from develoment to production how will you reset
Why update strategy and union transformations are active?
