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
- 6465 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
SELECT F1.COL1,F2.COL2,F2.COL3 FROM A F1,A F2 ORDER BY 1,2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain sql transformation in script mode examples in informatica
How to create the source and target database connections in server manager?
How to extract the informatica rejected data?
What are connected or unconnected transformations?
What are the databases that informatica can connect to windows?
what are 3 tech challenges/ common issues you face?
What you know about transaction control transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is workflow? What are the components of workflow manager?
What is an Integration service in Informatica?
What are the performance considerations when working with aggregator transformation?
How to update a particular record in target with out running whole workflow?
Scheduling properties,whats the default (sequential)
