Search:

Type: Posts; User: N SRIRAM K; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Answers
    1
    Views
    4,839

    Data Warehousing - Re: Transformation Logic

    Use CONCATE function in expression transformation.
  2. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    What is a DATA LINEAGE? How to configure it? (Designer)
  3. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    What is a SUPER GLUE Server in designer? How do we configure them?
  4. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    What is the use of LOAD CONFIGURATION in designer?
  5. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    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...
  6. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    Hi GEEKS,
    Could you please clear me what will be the difference between different connections like ODBC,DNS,DSN and Others?

    Thx
  7. Data Warehousing - Re: What is the next step to restore the data?

    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...
  8. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing-Informatica

    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)...
  9. Answers
    7
    Views
    9,517

    Data Warehousing - Datawarehousing Informatica Questions

    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...
  10. Answers
    5
    Views
    14,275

    Data Warehousing - Re: Using Rejected Rows

    You can't use filtered records in mapping. If you want to use them in further transformation then use Router instead of Filter.

    ...Thx
  11. Answers
    1
    Views
    4,672

    Data Warehousing - Re: Referential Integrity - Informatica?

    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
  12. Answers
    2
    Views
    3,452

    Data Warehousing - Re: Mapplets - transformations

    You can Include multiple transformations, a mapplet can contain as many transformations as you need.

    ...........Thx
  13. Answers
    5
    Views
    3,548

    Data Warehousing - Re: Informatica6x & Informatica7x

    Please don't go personally...that wastes time.


    Cheer .. Guys
  14. Answers
    2
    Views
    3,342

    Data Warehousing - Re: data warehousing

    I think question was not have any meaning. Don't you think ......Thx
  15. Answers
    2
    Views
    3,343

    Data Warehousing - Re: XML Object Mapping

    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...
  16. Answers
    6
    Views
    8,088

    Data Warehousing - Re: Syntax to insert data in the table

    Adding to the above friend's suggestion:

    Use same above they mentioned the syntax. but value must be like '21-Sep-2007'
  17. Thread: informatica

    by N SRIRAM K
    Answers
    14
    Views
    7,098

    Data Warehousing - Re: informatica

    Look up transformation is Passive because for each input row must get one output value (whether it is look up value or null).
  18. Answers
    7
    Views
    6,282

    Data Warehousing - Re: A typical scenario with Joiner....!

    G R E A T. I thought its not possible but you did it.
    Its great help if you explain.............Thx
  19. Data Warehousing - Re: how to find the diffrence berween two dates

    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
  20. Data Warehousing - Re: Is it possible to insert a recode into fact table

    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
  21. Data Warehousing - Re: How can we insert or update the records in target

    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...
  22. Data Warehousing - Re: Run 3 sessions in morning, 3 in evening and 1 session night

    Thanks SIPRA
  23. Answers
    3
    Views
    3,623

    Data Warehousing - Re: How to read files using informatica

    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...
  24. Answers
    3
    Views
    3,327

    Data Warehousing - Re: data warehousing

    Source Anlyzer --> Sources --> Import XML Definition

    Thx....@sriram_kumar@oneindia.in
  25. Answers
    6
    Views
    4,984

    Data Warehousing - Re: Flat files in a mapplet?

    No doubt, You can use Flat File as input in Mapplet.

    Thx.........@sriram_kumar@oneindia.in
Results 1 to 25 of 45
Page 1 of 2 1 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact