If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
1214Post New Informatica Questions
Describe an informatica powercenter?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the use of code page?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the difference between Active and Passive transformation?
Please let me know how to make encryption and decryption with example?
Explain sessions and how many types of sessions are there?
Explain direct and indirect flat file loading (source file type) - informatica
what is the hint? how to use it to reduce the query processing in program?
Different sorts of metadata that stores in the storage facility?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
lookup transformation with screenshots
Explain the code page compatibility?
Explain dynamic target flat file name generation in informatica
What are the differences between a connected lookup and unconnected lookup?