-
Informatica
I have 2 sources one is relational table with 7 ports second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?
-
Delete First 3 Rows & Last 3 Rows in Target Table
How to delete first 3 rows & last 3 rows in target table in Informatica?
-
Types of Dimension
What are the types of dimensions? Can you explainthe each type in short?
-
Multiple Flat Files Loading
If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?
-
Load only the First and Last Record
How to load only the first and last record of a flat file into the target?
-
find out duplicate records using aggregator
How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?
-
-
How do we Kill process if the process is running?
Do we have any specific number which we have to use with kill command?
-
-
What is the way to add the total number of records that have been read from SRC in the TGT file as last line?
What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.
-
-
-
Where and how you use UNIX Shell script in informatica
Can any one explain where we use Unix shell Scripts in informatica? Provided with example if possible.Thanks.......Jc
-
-
-
-
-
-