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

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

CTS, HCL, Infosys, TCS,

3 18782

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

Amdocs,

1 5492

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

Amdocs,

1 5579

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

Amdocs,

3 17548

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 4176

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

TCS,

1349

Plz can any one say me how to get the informatica certification materials and dumps

TCS,

1137

why normalizer transformation can not used in mapplet? plzzzz answer

Syntel,

2 13006

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

IBM,

2 4796

what are types of dimentions?

3 3570

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

IBM,

3 5875

Normalizer transformation is not involved in Mapplet.. why???

Wipro,

1 6818

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

TCS,

1 3260

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 3629

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

SeeInfoBiz, TCS,

1262


Post New Informatica Questions






Un-Answered Questions { Informatica }

Describe an informatica powercenter?

155


Whats the difference between informatica powercenter server, repositoryserver and repository?

180


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1297


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

3288


How do you convert single row from source into three rows into target?

131






Partition, what happens if the specified key range is shorter and longer

1540


Explain what transformation and how many are there in informatica?

141


How to update or delete the rows in a target, which do not have key fields?

165


What does role playing dimension mean?

157


Explain what is informatica metadata and where is it stored?

158


What is different between the data warehouse and data mart?

189


How does a sorter cache works?

170


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

180


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

178


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

149