Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

i have two source data there is no pk,fk how to join the two sources

TetraSoft,

5 7835

diffrence between command task and control task

iNautix,

1 5374

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 2000

Wipro,

3 4390

is it possible to index the data in cache of lkp transformation ?

1083

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

TCS,

5 5572

if we have a delimiters at unwanted places in a flat file how can we over come those.

1108

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 4830

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 .

TCS,

2 4748

what is song in infrmatica...?

CTS,

1210

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?

TCS,

3 7355


Post New Informatica Questions






Un-Answered Questions { Informatica }

Scheduling properties,whats the default (sequential)

946


What is deployment group?

181


How to create Target definition for flat files?

206


What is pmcmd command?

139


What the difference is between a database, a data warehouse and a data mart?

146






How to create a non-reusable instance of reusable transformations?

171


whats the logic to load the lower level of granularity of data to fact table.

1290


What are the different types of olap? Give an example?

133


Explain pushdown optimization and types in informatica

179


How to elaborate tracing level?

137


What do you mean incremental aggregation?

160


Difference between Target-based loading and constraint-based loading?

152


What is a code page?

198


explain one complex mapping with logic? sales project?

4714


What all join we can perform in LOOKUP transformation?

142