Interested to Buy Any Domain ? << Click Here >> for more details...
what are cost based and rule based approaches and what is
the difference?
- 1 Answers
- 5475 Views
- I also Faced
- E-Mail Answers
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Why sorter is an active transformation?
WHAT IS FACT TABLES?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
expain about the tune parameters?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Teradata 
