-
Joiner Transformation Master Detail
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
Read Best Answer
Editorial / Best Answer
ghola- Member Since Jul-2008 | Aug 15th, 2008
The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.
Secondly It is easier to cache the table with fewer number of rows.
Hence, using the table having the fewer number of rows as a master improves the performance.Raju R
- Oct 27th, 2015
@ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.
Rashmi
- Oct 18th, 2015
The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.
-
Transformation to Load 5 Flat files
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
Read Best Answer
Editorial / Best Answer
sarun5- Member Since Feb-2008 | Mar 13th, 2008
Guys I have got the answer for which I asked..here you go
This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep//ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txtIn session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.
Anurag
- Nov 27th, 2017
You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.
Ashok Gulagond
- Dec 16th, 2016
When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?
-
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
Sreeya
- Feb 21st, 2008
For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Anot...
Deepak Rajkumar
- Feb 18th, 2008
Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.
