Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the two flatfiles using the joiner t/r if there
is no matching port?
- 5 Answers
- 13645 Views
- Cegedim, I also Faced
- E-Mail Answers
Answer Posted / vin
create dummy1 port in flat file1
create dummy2 port in flat file2
assign the value '1' to both dummy1 and dummy2.
In the lookup condition use dummy1=dummy2. This is going to be always true so all the records are took into consideration.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
how many types of dimensions are available in informatica?
What is olap (on-line analytical processing?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the measure objects?
What are the types of caches in lookup?
Enlist the tasks for which source qualifier transformation is used.
what is the complex transformation you used in informatica
How can you generate reports in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What if the source is a flat-file?
Explain how to import oracle sequence into informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
what is the size of your data warehousing?
