Source
---------
eno , ename, sal
001,ank,1000
002,behe,2000
003,raj,2500
Target
-------
header :DDMMYYYY24MMSS timestamp
body: 001,ank,1000
002,behe,2000
003,raj,2500
footer: count(eno),sum(sal)
how to implement the same in a FF tgt?
Answers were Sorted based on User's Feedback
Answer / sachin
We can do it in two ways
1)in unix level.write a script to get the footer and header.
2)we can create 3 flows for header ,body and footer and append them one by one
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pooja
Watch Out this link:
https://www.youtube.com/watch?v=zKNVn9Rhn5o
It is similar to the question posted
| Is This Answer Correct ? | 0 Yes | 0 No |
In which circumstances that informatica server creates Reject files?
What are the components of Informatica? And what is the purpose of each?
In warehouses how many schemas are there?
How many mapplets u have created? and what is the logic used
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
why dimenstion tables are denormalized in nature ?
How to generate sequence numbers without using the sequence generator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How is Data Models Used in Practice?
how to return multiple columes through through un-connect lookup?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?