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
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|
where is the reject loader .
what is the difference between onsite & client site?
if i have a delimited file as source so how can we seperate this file into three diff targets?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
What are the mapping parameters and mapping variables?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
What is a command that used to run a batch?
What are the methods for creating reusable transforamtions?
.prm wirh repalce .txt is possible?
How to handle changing source file counts in a mapping?
Does Facttable Normalized or Denormalized?