Interested to Buy Any Domain ? << Click Here >> for more details...
sorce is a flatfile only 1st and last row should insert to
target how will u do?
- 2 Answers
- 9093 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
can u give example for factless fact table
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
On which transformations you created partitions in your project?
How to load the data from a flat file into the target where the source flat file name changes daily?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Write the different tools in the workflow manager?
how many types of dimensions are available in informatica?
Enlist the differences between database and data warehouse.
How many ways are there to do 'remove duplicate records in informatica'?
tell me about your project functionality
How can you differentiate between powercenter and power map?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In which transformation you cannot drag ports into it?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do we call shell scripts from informatica?
