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
- 9516 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 |
Plz can any one say me how to get the informatica certification materials and dumps
In ur current projectu have done any performance tuning of mappings?
What is the command used to run a batch?
Why filter transformation is an active one?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
How to extract sap data using informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
how to load rows into fact table in data warehouse
Enlist some properties of sessions.
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
How can you generate reports in informatica?
Teradata 
