Answer / jz

If Two Flat files having same coll then go for Union t/r to
join.

Answer / amedela chandra sekhar

If two flat files are having same structure then we can join
by using Union transformation.








Chandu

Answer / ajay konidena

No we can't join two flat file with out using joiner ,look
up

Answer / sarthak

With the help of command task...

cd dir_path
cat 1st_filename 2nd_filename >> 3rd_filename

Then,

create 1 flatfile and connect it to target.

In session property,
give the filename: 3rd_filename and its path

Answer / rahul patil

All the above approaches are not correct because question was to join two flat files... if we use indirect file or unix command or joiner trns, we could only union two files but not join.

If we have file1 --- 100 records and
file2 --- 100 records then through above approaches we would have only 200 records.

But a join without join condition would return cartesian product and in our case count should be 10000.


Rahul Patil
DWHKID

Answer / tulasi pavani.k

If two flat files are of same structure we can join by
creating one list file and by writing the the names of those
two flat files in one text file.

source file directory:c:/order.txt
source file type:indirect

Answer / murali udayagiri

Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.



Thanks,
Murali Udayagiri

Answer / avru.bal

we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup

Answer / sri

SORRY GUYS,BY MISTAKE I POST THE WRONG ANSWER.MAY BE I THINK
INDIRECT METHOD IS CORRECT ONE TO ACHIEVE THIS.

Answer / senthil

USE SOURCE QUALIFIER WHILE MAPPING CREATED ...

diffrence between command task and control task

1 Answers   iNautix,

What is sql query override? When did u use sql query override?

1 Answers   TCS,

Parameter and variable differences

0 Answers  

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

What is the use of code page?

0 Answers