Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

Can we create out put ports in source qualifier t/r?

TCS,

5 15412

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

Cap Gemini,

5 9474

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 4528

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 4907

what is SDLC way of code development?

2043

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Cap Gemini, CTS,

6 15341

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

Cap Gemini, Cognizant,

2720

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

Bosch,

2131

What is the difference between Bulk Load and Normal Load

TCS,

3 13171

What is limitations of truncate and load option

Cap Gemini,

1 9964

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

Cap Gemini,

10 14350

Design a mapping to get year of join for each employee.

Accenture,

4 9530

Can we combine a flatfile and a database table using an UNION transformation?

Accenture,

2 12855

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11537

What are the types of error logs available in Informatica?

1 6287


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the popular informatica products?

1012


What does refresh system mean, and what are its distinctive choice?

1181


What is primary and backup node?

1127


What is target designer and target load order?

1104


What is informatica?

1155


What is xml source qualifier transformation in informatica?

1217


Tell me about MD5 functions in informatica

929


can anyone explain me about retail domain project in informatica?

7947


What do you understand by SOA of Informatica?

989


Explain pushdown optimization and types in informatica

1077


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075


How to handle decimal places while importing a flatfile into informatica?

1192


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?

1932


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9821


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125