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
Answer Posted / raj
In SQL override write tha fallowing query
select a.id,b.name,b.sal from <table name> a,<table name> b
The above query is nothing but a cartesion product.
Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
How to load a Dimension ? and how to load a fact table?
Quickly characterize reusable change?
What is joiner transformation?
What are the types of presistent cache in look up tr.
Scheduling properties,whats the default (sequential)
What are the types of caches in lookup? Explain them.
How can you increase the performance in joiner transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the advantages of using informatica as an etl tool over teradata?
How do you load only null records into target?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to call shell scripts from informatica?
Why do we need informatica?
What is a surrogate key?
Why do you use Mapping Parameter and mapping variable?