Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
- 4 Answers
- 9258 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradosh
if the flat files has diff stracture then
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>
that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.
join takes diferent sources
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vijay
you have two flat-files with u.
prepare two source instances with the structure you have as
oracle relational tables. after that change them to
flatfiles in the source instances.
then connect to the target's that u already prepared by
simple-pass mapping. now you have two relational source
tables with u,then join the tables using joiner.
--------------------------------------------------
how to join one relational and one flat file?
same as above convert the flatfile to relational table
through simple-pass mapping. now join two relational tables
using joiner in the same mapping itself.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi sravanti
Could U please explain how to join ?
| Is This Answer Correct ? | 0 Yes | 1 No |
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What is the difference between bitmap and btree index?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
A session S_MAP1 is in Repository A. While running the session error message has displayed
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
How many repositories can we create in Informatica?
Where do you create/define mapping parameter and mapping variable?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
what is flat file override?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the Difference between SetVariable and setmaxvariable in informatica?
Teradata 
