What if the source is a flat-file?
No Answer is Posted For this Question
Be the First to Post Answer
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
4 yrs etl devloper roles and responsibilities?any body give solutions
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Why should we use star schema in datawarehouse design?
can anyone explain me about retail domain project in informatica?
What are the types of presistent cache in look up tr.
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to elaborate tracing level?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'