 Related Questions Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data. In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic? Read Answers (6) | Asked by : Reddy I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance 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 (2) | 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 How to implement this situation:have one source and one target,while load into the target first delete then insert? Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up Read Answers (2) | Asked by : Grayva Hi recently i hav done informatica,now preparing 4 interview,so my questions may be silly one,plz help me.what is load manager? Read Answers (3) | Asked by : rekha v s I have a flat file as my source containing 100 records and i have two load this f;lat file data into 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 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 Write a query to retrieve latest records from the target table means if we have used scd2 version type of dimension, than retrieve the record with highest version no.for eg verno id loc 1 100 bang 2 100 kol 1 101 bang 2 101 chenwe have to retrieve 100/kol and 101/chen. how it is possible through query.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
