My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 20003 4390
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?3 4959
how can import the data from the flat files?2 3930
major difference between normal loading and bulk loading?6 8354
explain about session partitions ?1 4286
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
Can I create one wrkflw which will run different wrkflws on schedule time?3 4176
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
what is song in infrmatica...?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Scheduling properties,whats the default (sequential)
What is deployment group?
How to create Target definition for flat files?
What is pmcmd command?
What the difference is between a database, a data warehouse and a data mart?
How to create a non-reusable instance of reusable transformations?
whats the logic to load the lower level of granularity of data to fact table.
What are the different types of olap? Give an example?
Explain pushdown optimization and types in informatica
How to elaborate tracing level?
What do you mean incremental aggregation?
Difference between Target-based loading and constraint-based loading?
What is a code page?
explain one complex mapping with logic? sales project?
What all join we can perform in LOOKUP transformation?