Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 37805 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyank
one varibale port.
Var_port=IIF(Var_port=0,1,Var_port+1)
Out_port=Var_port
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / nagaraj
hi, kalyan
can u write that query in sql override.
| Is This Answer Correct ? | 0 Yes | 3 No |
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
List the transformation in informatica.
what is a transforamation?
What is query panel?
Define pmcmd command?
When the informatica server marks that a batch is failed?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How union transformation is used?
Teradata 
