Search:

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...