Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita.

Read Answers (3) | Asked by : Arpita

Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan

Read Answers (4) | Asked by : Kamalnayan Maramraj

Tags : RDBMS

I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana

Read Answers (6) | Asked by : nayana

Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance

Read Answers (1) | Asked by : ramki

Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica. The Target are Oracle tables. 1-80 columns: 1st target 81-200 columns:2nd target How can I split that single COBOL file data into two data files and How can I load that data using Informatica. Thanks in Advance

Read Answers (1) | Asked by : GeekAdmin

When we use only Aggregator transformation in our mapping for approx 5 milion records it takes 40-42min time but when we use it with a sorter transformation, the time reduces to 12 -13 min. We have also noticed that throughput of select statement from source was also very high. It aggregates grouped data quickly is ok but why throughput of select statement was also higher using sorter transformation?

I have a flat file as my source containing 100 records and i have two load this f;lat file data into two different targtets .these two targets recide in two different schemas actually?

Read Answers (1) | Asked by : anil

Can any one give me the query to delete duplicate records from a table. not selection of duplicates deletion of duplicate records. sql query only

Read Answers (3) | Asked by : Ramakrishna

How to recognize zero records in source flat file?I read a flatfile and I should ABORT () if there are no incoming records. How I can do this? The source file is on Unix, so I could use shell scripts, but I would to do this in Informatica....Another questions:can I use Unix pipe as input ("flat")file? A fast method to determine which record I'm processing now? i.e. in the 5th record of the flat file I have to do something special, how to find out this record? ThanksSergej

Read Answers (1) | Asked by : Sergej

Hi frnds, let me know the solution for this. i have emp table with eno, ename as columns with duplicate rows.Ex : eno ename 1 kiran 2 sena 3 naveen 1 kiran 4 dev 3 naveen 1 kiran 5 loki 3 naveen 1 kiran 6 shashi 1 kiran etc... so iwant to find out the third occurance

Read Answers (3) | Asked by : kiran kumar parsha