can we import source table without using source qualifier? if
yes then how? if no then why?
Answers were Sorted based on User's Feedback
What is query panel?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
how to convert the .doc docs into .txt format using informatica
Limitation of REPLACESTR. Is there any character limitation to it.
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
in which situations do u go for snowflake schema ?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
How do you recover rows from a failed session
Could any one to tell How to use the Oracle Analytic functions in Informatica?