Skip navigation
Contact Us
514 Views 1 Reply Latest reply: Nov 6, 2012 1:52 AM by Veeru B RSS
vivek N Novice 39 posts since
Aug 9, 2011
Currently Being Moderated

Nov 5, 2012 10:10 PM

DATE _ FORMAT

hi designers,

 

.can i get the count in aggrigator  with out  group by?

 

.can i get two return ports using unconnected lookup?

 

.can i use sql transformation  instead of look up?

 

.what is the default  date reading format from a table ?

 

 

 

expecting the  expressive answers...

 

regards,

vivek.....

  • Veeru B Master 1,242 posts since
    Sep 27, 2010
    Currently Being Moderated
    Nov 6, 2012 1:52 AM (in response to vivek N)
    DATE _ FORMAT

    Hi Vivek,

     

    Please find the answers below.

     

    .can i get the count in aggrigator  with out  group by?

    Yes, you can get count. that count is equal to total record count of incoming data.

     

    .can i get two return ports using unconnected lookup?

    As per the informatica logic NO.  But you can achive this by using sql override in lookup. functionally it one out put only. you an concat two attributes in SQL override and split in next transformation.

     

    .can i use sql transformation  instead of look up?

    Its depending on what's your requirement.

     

    .what is the default  date reading format from a table ?

     

    Are you asking about date format or date if its null in table?

     

    Regards,

    Veeru

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points