In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
- 5 Answers
- 8462 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
It can be one of the solution
tgt table contains two columns
src->sq->exp1-->>tgt(1) one instance of tgt table.
---------exp2-->>tgt(2) second instance of tgt table.
*after sq forward c1 and c2 to exp1
and c1 and c3 to exp2
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
Tell me about MD5 functions in informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
Write the unconnected lookup syntax?
Performance tuning in UNIX for informatica mappings?
What is informatica etl tool?
What is a stored procedure transformation?
Write the prerequisite tasks to achieve the session partition?
What do you mean incremental aggregation?
Have you worked with/created Parameter file
Explain sql transformation in script mode examples in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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?
EXL informatica Questions
Please let me know how to make encryption and decryption with example?
