Can any body tell me the configuration of informatica in UNIX, or if it is lenghty pls send the doc. thanks in advance
What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?
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?
When i try to connect to the repository server i am getting this message can someone help me..Starting Repository [infa_rep](6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.(6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.(6016|1292) Informatica Repository Agent starting up.(6016|1292) Security
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
Latest Answer : using source analyzer and warehouse designer ...
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
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
