Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
Answer Posted / kuttu
if you require only 5 rows in the target we can use 5
target aliases and acheive it.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the modules in Power Mart?
how would u estimate the size of Lookup transform data and index cache?
Explain about etl data integration software?
tell me few points when u become TL
What is tracing level? How many types of transformations supported by sorted input?
what are the concerns of OLTP and DSS systems?
What are the names of the layers in etl?
What is full load & incremental or refresh load?
how do use session mapping parameters ?(in which transformation)
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What are dimensions?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how do u really know that paging to disk is happening while u are using a lookup transform?
Difference between flat files and relational sources?
What is a materialized view log?