Two types of datamovement modes in infomatica. They are
1) unicode (support multi languages and selection sort algorithm is used)
2) ascii (support single languages and binary sort algorithm is...
Type: Posts; User: cme_prak; Keyword(s):
Two types of datamovement modes in infomatica. They are
1) unicode (support multi languages and selection sort algorithm is used)
2) ascii (support single languages and binary sort algorithm is...
Hi,
Try to analyse the Error, wht kind of error u r facing?
There is some standard Error codes.
RR - Relational Reader (This is for Relation Source(Any Database source))
FR - File Reader...
Right Click the Session --- Edit, in that window the mapping name will display.
Hi,
Column to Rows
------------------
Using Normalizer Transformation. We can convert Columns values to Row.
Rows to Columns
-------------------
Hi,
Lookup transformation points any one of the table. It may be relational table or flat file. Other transformations points the column of any table.
Using lookup transformation, we can...
Hi,
Logic
------
SRC----EXP-----FIL------TGT
In expression create one varaible port(V_SEQ_NO)
STEP 1: Write this expresssion in variable pt->
Hi Vikas,
Please do SAP HR Module. It is very useful for ur career, because u did MBA HR.
All the best for bright future.
Cheers,
Prakash
Hi,
Three levels for BOXI R2 certification.
Level 1 : SABE 201
Level 2 : SABE 301
Level 3 : SABE 401
If u complete this three levels only u get the certificate from the SAP company.
Hi,
1) We cant able to create versioning.
2) Right click the object - > View History, the window will open.
go to Tools - Compare
3) We have to enable versioning, while creating...
Hi Raju,
Using Round Robin Partition, we can do that scenario.
Thx,
Prakash
Hi,
src table:
eno colname colval
-------------------
1000 name prakash
1000 age 24
1000 sal 25000
1001 name srini
1001 age 21
1001 sal 25000
Hi,
SRC ---> EXP ---->[use CUME function to get the running total] ------>AGG----->TAR
Thx,
Prakash
Hi,
no,
DD_INSERT - 0
DD_UPDATE - 1
DD_DELETE - 2
DD_REJECT - 3
In Lookup[if u enable Dynamic Cache, the NewLookupRow default port is created]
Hi,
Yes, we can use flat file as a lookup table, but we can use static cache only.
Sorted input option is enabled only for the flat files[In Lookup properties].
Thx,
Prakash
Hi Lakshmi,
Please check the server name(ORA OR ORACLE...) in ur backend. Using the below cmd u can get the server name
SELECT NAME FROM V$DATABASE
Pls get back to us incase of queries.
...
Hi
With BusinessObjects Voyager, your business analysts can explore OLAP data using a tool designed specifically for them—one that delivers a full range of functions for the analysis of...
Hi Sarun,
Pls chk ur source and target name. If ur source and target name are same, the target table didn't get the records from the source.
Prakash
:)
Informatica 8.1
Hi,
In Group by clause, its dont accept the text datatype. Pls chk whether ur one of the column may be a text.
Thx
Prakash
Hi Sriram,
Using TO_FLOAT conversion function, we can get the exact decimal number.
Thx
Prakash
Hi,
1. It supports Web Services.
2. Looping Concept is possible in Informatica 8.1.1
3. Auto Cache(Lookup, Aggergator, Rank, Joiner]
4. JAVA Transformation is avaliable in 8.1.1.
The Site is...
Hi guest, using mod function mod(portname,2)=0 - even rows mod(portname,2)=1 - odd rows thx prakash
Hi,
Column to Row - Normalizer Transformatin
Row to Column - Using an Expression and Aggregatoru can achieve that task.
Please get back to us in case of queries.
Thx
Prakash:)
Hi,
How to create a ODBC Sources & Targets(EXCEL & ACCESS)?
Thx
Prakash:)
Hi Mark,
I think lookup is a costly transformation, using expression itself we can achieve this task.
SEQ_NO - Variable Port
IIF(ISNULL(SEQ_NO),1,SEQ_NO+1)
Please get back to us in case...