1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

what is the use of Data Mart?

IBM,

5 6154

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

iGate, Qualcomm,

2 6887

performance tuning of Informatica

 1 4568

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

Informatica,

5 7586

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

Sapient,

2 5544

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

IBM,

3 6779

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

Polaris,

5 7553

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

Polaris,

4 5853

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

TCS,

1500

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

TCS,

1452

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

TCS,

2 6117

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

TCS,

2 5113

TELL ME ABOUT WORK FLOW SCHEDULING?

TCS,

3 6812

r u done any partitions in ur project?

TCS,

1386

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

Polaris,

3 10354

Post New Informatica Questions

Un-Answered Questions { Informatica }

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1016

What is the difference between STOP and ABORT options in Workflow Monitor?

682

What is workflow manager?

560

How are indexes created after completing the load process?

969

How to join three sources using joiner?

554




Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6329

Define filter transformation?

610

What are pre and post-session shell commands?

722

What is the status code in stored procedure transformation?

673

what is SDLC way of code development?

1548

How can we handle two sessions in informatica?

602

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1612

What is the meaning of decode in informatica?

634

What are the different lookup cache(s)?

606

What is InformaticaPowerCenter?

675

For More Un-Answered { Informatica } Questions Click Here