Use CONCATE function in expression transformation.
Type: Posts; User: N SRIRAM K; Keyword(s):
Use CONCATE function in expression transformation.
What is a DATA LINEAGE? How to configure it? (Designer)
What is a SUPER GLUE Server in designer? How do we configure them?
What is the use of LOAD CONFIGURATION in designer?
Could any one please tell me how informatica behaves in the following situation?
(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS...
Hi GEEKS,
Could you please clear me what will be the difference between different connections like ODBC,DNS,DSN and Others?
Thx
You are telling that completely removed, so there is no back up expected then Start refilling it record by record by using same sources and targets.
:-))
Don't GROAN to me. Answer should be...
We encounter a problem in Informatica when handling number datatypes from Oracle.
In the Oracle database, I have the values as "46516387.47" and "46513795.02". I have defined them as number(30,10)...
I have had one requirment URGENT:
SRC (flat file) --> SRC QFR --> EXP --> STR PROC --> TGT
Inputs for stored procedure transformation are 3,
1) name string 2) add string and 3) S_date...
You can't use filtered records in mapping. If you want to use them in further transformation then use Router instead of Filter.
...Thx
You can create Primary and Foreign key relationships through the informatica Designer. Even the relationship wasn't present in physical database. You can achieve from designer.
Thx
You can Include multiple transformations, a mapplet can contain as many transformations as you need.
...........Thx
Please don't go personally...that wastes time.
Cheer .. Guys
I think question was not have any meaning. Don't you think ......Thx
I think its not possible. You can either import XML definition or can import File. But you can't change file definition as XML but you can change it as Teradata,VSAM,Informix,DB2...etc.
I think...
Adding to the above friend's suggestion:
Use same above they mentioned the syntax. but value must be like '21-Sep-2007'
Look up transformation is Passive because for each input row must get one output value (whether it is look up value or null).
G R E A T. I thought its not possible but you did it.
Its great help if you explain.............Thx
Raviayyappan is right. Adding to that please make sure the date format must be equal, since SYSDATE may take Time stamp that means date with time that makes the diff. ..........thx
If you claim that EMP as FACT table and DEPT as dimension then Not possible because FACT must have the referential integrity rule with their dimensions.
Thx....@sriram_kumar@oneindia.in
Yes, we can insert and update data in TGT.
But the PowerCenter Server does not update the cache while it processes the transformation.
It uses the data avail in static cache, it can't be updated...
Thanks SIPRA
I don't think B Arunkumar is wrong. Some times before giving suggestion on the question..we must have known some things clearly. He might have known answer or we can get some clue from them.
I am...
Source Anlyzer --> Sources --> Import XML Definition
Thx....@sriram_kumar@oneindia.in
No doubt, You can use Flat File as input in Mapplet.
Thx.........@sriram_kumar@oneindia.in