how to join two flat file if they have diff. structure?how to join one relational and one flat file?
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 |
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
Can we insert ,update ,delete in target tables with one update strategy tran.?
What are some examples of informatica etl programs?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
write a query to get maximum salary from the employers table without duplicates....kindly help me
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
How can you generate reports in informatica?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What are the different types of Type2 dimension maping?