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
- 9473 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 |
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Do you have knowledge in ralph kimball methodology
Why do you use Mapping Parameter and mapping variable?
Why the workflow is failed after running two hours in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
how we can load rejected record's at run time?(not through bad files)
How to send duplicates to one target and unique rows to one target?target is empty
Teradata 
