Interested to Buy Any Domain ? << Click Here >> for more details...
what are business components in Informatica?
- 2 Answers
- 11035 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anilkumar
Normalization does not allows duplicate records where as de-Normalization allows Duplicate Records also.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the meant by Normalization and de-normalization?
how does the server recongnise the source and target databases.Elaborate on this
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
How many types of transformations supported by sorted input?
What are the ETL Testing Operations?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is data cleaning?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
Eliminating of duplicate records without using dynamic lookups
Teradata 
