Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table i want to delete first and last records and
load in between records into target? how can it possible?
- 3 Answers
- 10014 Views
- HCL, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / davankumar
In the aggregator t/r we have aggregate functions first and
last.with these we have to calculate.
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the databases that informatica can connect to windows?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to handle decimal places while importing a flatfile into informatica?
What happens when a session fails and you click on recover?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is data caches/ index caches?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a surrogate key?
What are the types of caches in lookup? Explain them.
What are junk dimensions?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
