If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 14877 Views
- I also Faced
- E-Mail Answers
Answer Posted / palani
Yes. For better performance filter the records using Unix's
Head,Tail commands. Pass the particular records to SQ and
Load.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a connected transformation?
Can anyone tell me the new features in Informatica 9 Version?
How can we use mapping variables in informatica? Where do we use them?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Under what conditions selecting sorted input in aggregator will still not boost session performance?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the components of workflow manager?
what is SDLC way of code development?
What the difference is between a database, a data warehouse and a data mart?
What are the different options available for update strategy?
What is the function of aggregator transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can we create index after completion of load process?
How to load last n records of file into target table - informatica
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
