In Datastage, we have row generator stage to generate dummy
row.
Is there any such transformation in Informatica.
Thanks in advance,
Kumar
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
To achieve the session partition what r the necessary tasks u have to do?
How to update a particular record in target with out running whole workflow?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
Can i create a lookup table without cache.
What happens if the info. Server doesn't find the session parameter in the parameter file?
what is semi-additive fact?where did u used?
What is the status code?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?