How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / raja
we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
what are the deliverables?in your project?
Can we change Dynamic to Static or Persistent cache? If so what happens?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
I have a flat file, want to reverse the contents of the flat file
How can you define user defied event?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the difference between writing a joiner query in ANSI style and THETA style?
how we can load rejected record's at run time?(not through bad files)
How many ways a relational source definition can be updated and what are they?
What all are steps in up gradation of Informatica server?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to extract the informatica rejected data?
What is meant by LDAP users?
Enlist the advantages of informatica.
What is an expression transformation in informatica?