How big was your fact table
No Answer is Posted For this Question
Be the First to Post Answer
In target table how to display the system time
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
can we generate reports in informatica ? How?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
create a mapping to retrieve the employees who are getting salary greater than average salary?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
In update strategy target table or flat file which gives more performance ? why?
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.
what is parallel querying and what r hints.